Invoice Detail Adjustments

Invoice Detail Adjustments allow the user to adjust line items on an Invoice. Invoice Detail Adjustments impact Sales and G/L for the current period. This document will take you through the steps to post an Invoice Detail Adjustment and illustrate the resulting effects on the Customer Invoice, Account Inquiry and Reporting. Also See Related Topics.

 

Note: Invoice Detail Adjustments can be created with an optional Credit Memo. Click Credit Memo for instructions.

 

Navigate To: Accounting>Account Inquiry

 

Invoice Detail Adjustments

 

1. Enter or Search Customer/Site number OR Enter Invoice number to be adjusted in the Invoice # field.
2. In the Invoice List, right click on the Invoice to be adjusted.
3. Select Adjustment>Invoice Detail Adjustments

4. Invoice Adjustments window will open. Each line item contained on the invoice will be listed in the Invoice Details grid.
5. Click in the Adjustments field beside the line item to be adjusted. Click Me For A Tip!Click on the column header to sort the line items by that field. For instance, click on the Description column to sort/group all line items by their Description.
6. Enter the Adjustment amount as positive or negative.
7. Select an Adj. Reason from the drop down menu.
8. *Adj. Qty is only applied when Flat Tax or Flat Surcharge exists on an Invoice. The value for this field will default only when Flat Tax or Flat Surcharge exists but can be changed by the user if needed.
9. Note field entry is optional, but recommended for future reference.

10. Verify the Total Adjustments and Total Balance.
11. Save Changes.

Account Inquiry

• Invoice List will display the Adjustment amount and the Balance will reflect the adjustment amount.
• Invoice Details will display each Invoice Detail Adjustment line item.

Invoice

• If Credit Memo's are NOT utilized, the Invoice Detail Adjustments are displayed in the body of the invoice below the adjusted line item.
• The Tax is now calculated on the new invoice balance.

 

Reporting

 

Sales Journal

• Sales Journal will include all Invoice Detail Adjustments posted for the period reported.
• Corrected Invoices include an asterisk(*) after the Invoice Number.
• Adjustment Reason and amount will be listed below the Invoice.
• Invoice Total will reflect the invoice detail adjustments.

The below example is displayed in Detail

• When the Sales Journal is run in Summary or Detail, there is an option to Separate Receivables and Rebates. This option will report Receivables and Rebates in separate groups.
• When the Sales Journal is run in Detail, there is an option to report Only invoices with corrections. This option will only report invoices that include and Invoice Detail Adjustment.

 

G/L Revenue

• G/L Revenue includes Invoice Detail Adjustments in the Charges.

See the below example for Service Type M1 - Monthly Service:

 

Related Topics

Adjustment Reporting

AR Balance Adjustments from Account Inquiry

AR Balance Adjustments from Post Adjustments

Credit Memo

Adjustment Reason Code